AutoIncrement Property

       

Returns or sets a value that determines if the properties that set the current data point are incremented during data entry without manually setting the Column and Row properties.

Syntax

object.AutoIncrement [ = boolean]

The AutoIncrement property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
boolean A Boolean expression that specifies whether the current data point is incremented, as described in Settings.

Settings

The settings for boolean are:

Setting Description
True When the Data property is changed, the Row property updates to the next row in the column. If you are at the end of a column, the Column property increments to the next column.
False (Default) The current data point is not incremented.